MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Artist Alpha Sort = 11760

View and edit SQL

Suggested facets: Object Name, Title, Culture, Artist Role, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
118756 1988.423.1 0 1 207775 European Sculpture and Decorative Arts 3 Pitcher 296 Pitcher British, Linthorpe, Yorkshire 3393         Factory|Designer 389   Linthorpe Pottery Works|Christopher Dresser British, 1879–1889|British, Glasgow, Scotland 1834–1904 Mulhouse   Linthorpe Pottery Works|Dresser, Christopher 11760 British|British, Scottish 336 1879 |1834 1889 |1904 1879–82 1879 1882 Glazed earthenware 9554 Height: 8 7/16 in. (21.4 cm) Gift of Cynthia Hazen Polsky, 1988                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
118757 1988.423.2 0 1 207776 European Sculpture and Decorative Arts 3 Pitcher 296 Pitcher British, Linthorpe, Yorkshire 3393         Factory|Maker 400   Linthorpe Pottery Works|Christopher Dresser British, 1879–1889|British, Glasgow, Scotland 1834–1904 Mulhouse   Linthorpe Pottery Works|Dresser, Christopher 11760 British|British, Scottish 336 1879 |1834 1889 |1904 1879–82 1879 1882 Earthenware 21 Height: 6 1/4 in. (15.9 cm) Gift of Cynthia Hazen Polsky, 1988                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
119104 1993.275 0 1 208140 European Sculpture and Decorative Arts 3 Vase 7 Vase British, Linthorpe, Yorkshire 3393         Factory|Designer 389   Linthorpe Pottery Works|Christopher Dresser British, 1879–1889|British, Glasgow, Scotland 1834–1904 Mulhouse   Linthorpe Pottery Works|Dresser, Christopher 11760 British|British, Scottish 336 1879 |1834 1889 |1904 1879–82 1879 1882 Glazed earthenware 9554 Height: 10 3/8 in. (26.4 cm) Gift of Robert L. Isaacson, 1993                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
119520 1996.360 0 1 208556 European Sculpture and Decorative Arts 3 Pitcher 296 Pitcher British, Linthorpe, Yorkshire 3393         Factory|Designer 389   Linthorpe Pottery Works|Christopher Dresser British, 1879–1889|British, Glasgow, Scotland 1834–1904 Mulhouse   Linthorpe Pottery Works|Dresser, Christopher 11760 British|British, Scottish 336 1879 |1834 1889 |1904 1879–82 1879 1882 Earthenware 21 Height: 7 11/16 in. (19.5 cm) Gift of Leah and David Roland, 1996                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
121264 2001.549 0 1 210899 European Sculpture and Decorative Arts 3 Wave bowl 8721 Wave bowl British, Linthorpe, Yorkshire 3393         Manufacturer|Designer 18 Attributed to Linthorpe Pottery Works|Christopher Dresser British, 1879–1889|British, Glasgow, Scotland 1834–1904 Mulhouse   Linthorpe Pottery Works|Dresser, Christopher 11760 British|British, Scottish 336 1879 |1834 1889 |1904 ca. 1880 1875 1885 Glazed earthenware 9554 Overall: 7 × 7 × 4 1/2 in. (17.8 × 17.8 × 11.4 cm) Purchase, James David Draper Gift, in memory of Robert Isaacson, 2001                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
139956 1990.282.2 0 1 237236 European Sculpture and Decorative Arts 3 Serving fork 8004 Serving fork British, Linthorpe, Yorkshire 3393         Factory|Designer 389   Linthorpe Pottery Works|Christopher Dresser British, 1879–1889|British, Glasgow, Scotland 1834–1904 Mulhouse   Linthorpe Pottery Works|Dresser, Christopher 11760 British|British, Scottish 336 1879 |1834 1889 |1904 1879–82 1879 1882 Glazed brown earthenware, silver 25438 Length: 10 1/2 in. (26.7 cm) Purchase, Friends of European Sculpture and Decorative Arts Gifts, 1990                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
139957 1990.282.3 0 1 237237 European Sculpture and Decorative Arts 3 Spoon 78 Spoon British, Linthorpe, Yorkshire 3393         Factory|Designer 389   Linthorpe Pottery Works|Christopher Dresser British, 1879–1889|British, Glasgow, Scotland 1834–1904 Mulhouse   Linthorpe Pottery Works|Dresser, Christopher 11760 British|British, Scottish 336 1879 |1834 1889 |1904 1879–82 1879 1882 Glazed brown earthenware, silver 25438 Length: 10 1/2 in. (26.7 cm) Purchase, Friends of European Sculpture and Decorative Arts Gifts, 1990                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
139958 1990.282.1 0 1 237238 European Sculpture and Decorative Arts 3 Salad bowl 763 Salad bowl British, Linthorpe, Yorkshire 3393         Factory|Designer 389   Linthorpe Pottery Works|Christopher Dresser British, 1879–1889|British, Glasgow, Scotland 1834–1904 Mulhouse   Linthorpe Pottery Works|Dresser, Christopher 11760 British|British, Scottish 336 1879 |1834 1889 |1904 1879–82 1879 1882 Glazed brown earthenware, silver 25438 5 × 10 in. (12.7 × 25.4 cm) Purchase, Friends of European Sculpture and Decorative Arts Gifts, 1990                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
409481 2016.178.3 0 1 670806 European Sculpture and Decorative Arts 3 Vase 7 Bottle vase British 6         Manufactory|Designer 484   Linthorpe Pottery Works|Christopher Dresser British, 1879–1889|British, Glasgow, Scotland 1834–1904 Mulhouse   Linthorpe Pottery Works|Dresser, Christopher 11760   1879 |1834 1889 |1904 ca. 1882 1877 1887 Glazed earthenware 9554 Overall (confirmed): 9 1/2 × 4 7/8 × 4 7/8 in. (24.1 × 12.4 × 12.4 cm) Gift of Florence and Herbert Irving, 2016                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 120.303ms · Data license: CC0 · Data source: metmuseum/openaccess